


for i in range(10,60):
  sql = """insert into users(USERNAME, PASSWORD, EMAIL, NAME, USERROLE, COUNTRY, LANGUAGE, CREATEDON, ACTIVE) 
        values('uu%2d','uu%2d','uu%2d@mail.com','uu%2d',1,'zh_CN','zh_CN',now(),1);""" %(i,i,i,i)
        
  #print sql
  
  sql = """INSERT INTO members (FK_USER_ID, SEX, COUNTRY, BIRTHDAY, CITY, INTRODUCE, TARGET_LANG, LANGUAGE, CREATEDON, ACTIVE)
  VALUES(%d, 1, 'zh_CN', '1998-01-08', 'BJ', 'HH introduce jjjjjfdfjdsf z', 'en_US', 'zh_CN', now(),1);""" %(i)
  
  #print sql
  
  sql = """INSERT INTO vocabularys (FK_CAT_VOCABULARY_ID, TARGET_LANG, AUDIO_PATH, PHONETIC, EXPLANATION, LANGUAGE,  CREATEDON, ACTIVE) 
    VALUES  (1, 'en_US', NULL, 'lala', 'lala exp', 'zh_CN',  now(), 1);
    """ 
  
  print sql
